Functions

PostgreSQL provides four kinds of functions:

Every kind of function can take base types, composite types, or combinations of these as arguments (parameters). In addition, every kind of function can return a base type or a composite type. Many kinds of functions can take or return certain pseudo-types (such as polymorphic types), but the available facilities vary.

Just simply click to open an object pane for Function. A control-click displays the popup menu or using the object pane toolbar below, allowing you to create new, edit and delete the selected function.

Create Function

To create a new function

To create a new function with the same properties as one of the existing function has (using drag and drop method)

Apply to: current schema {same connection and database}
Apply to: different database {same connection}
  different database {different connection} (Data Transfer tool will be activated)
  • Select the function(s) for copying in the object pane.
  • Drag and drop the chosen function(s) to the target database.
  • Select one of the following options:

    • Copy
    • Cancel

To create a new function with the same properties as one of the existing function has

To create a new function with modification as one of the existing function

Edit Function

To edit the existing function (manage its properties etc)

To change the name of the function

Run Function

To run a function in the navigation pane/object pane

To run a function in the Function Designer

Delete Function

To delete a function

Achieve Function Information

To achieve a function information